Core Data Access with Microsoft Visual Studio 2005

Module 1: Connecting to Databases and Reading Data

Connecting to a Database
Saving a Connection String Securely in an Application Configuration File
Retrieving Data from a Database
Handling Connection Events and Exceptions
Configuring and Using Connection Pooling

Module 2: Querying and Updating Databases by Using Commands

Creating and Running Query Commands
Creating and Running Parameterized Commands
Creating and Running Update Commands
Using Globalized Formats for Storing and Accessing Data (if time permits)

Module 3: Performing Transactional Operations

Performing Data Updates within a Transaction
Choosing an Appropriate Isolation Level for a Transaction
Enlisting in a Distributed Transaction
Managing Transactions in the Data Tier

Module 4: Performing Disconnected Operations Programmatically

Creating a DataSet Programmatically
Populating and Saving a DataSet
Adding, Modifying, and Deleting Data in a DataSet
Merging DataSets
Creating and Using DataViews

Module 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards

Creating a Typed DataSet by Using the DataSet Designer
Loading, Displaying, and Saving Data in a Typed DataSet
Adding Code to a Typed DataSet
Creating a Typed DataSet by Using the Data Source Configuration Wizard
Adding Queries to a Table Adapter

Module 6: Performing XML Operations on Disconnected Data

Saving a DataSet as XML Data
Loading a DataSet from XML
Saving and Loading DataSet Schema Information

Module 7: Reading and Writing XML Data

Writing XML Data by Using XmlWriter
Reading XML Data by Using XmlReader

Module 8: Processing XML Data by Using DOM

Reading XML Data by Using DOM
Writing XML Data by Using DOM

Advanced Data Access with Microsoft Visual Studio 2005

Module 1: Minimizing and Handling Database Operation Conflicts

Reading Committed Data by Using Locks
Reading Committed Data by Using Statement-Level Snapshots
Reading Committed Data by Using Transaction-Level Snapshots
Handling Data Concurrency by Using ADO.NET

Module 2: Handling Large Objects

Reading Large Values from SQL Server
Writing Large Values to SQL Server
Conserving Resources When Writing Large Values to SQL Server

Module 3: Enhancing Database Performance

Accessing Multiple Result Sets Concurrently
Performing Asynchronous Data Access Operations
Performing a Batch Update
Performing a Bulk Data Copy

Module 4: Creating Managed Code Objects for SQL Server 2005

Creating Managed Stored Procedures and Triggers
Creating Managed User-Defined Functions
Creating a Managed Aggregate
Creating a Managed User-Defined Type
Importing Existing Assemblies into SQL Server 2005

Module 5: Querying XML by Using XPath

Selecting XML Data by Using XPathNavigator
Evaluating XPath Expressions by Using XPath Navigator
Creating and Using Compiled XPath Expressions
Editing XML Data by Using XPathNavigator

Module 6: Transforming XML by Using XSLT Style Sheets

Transforming an XML Document by Using an XSLT Style Sheet
Resolving External Resources During XSLT Processing
Passing Parameters into an XSLT Style Sheet
Creating and Using Extension Objects

Core Web Application Technologies with Microsoft Visual Studio 2005

Module 1: Creating a Web Application

Creating a New Web Application
Configuring and Building a Web Application

Module 2: Programming a Web Application

Implementing Non-Default Event Handlers
Detecting Browser Capabilities and Setting Page Header Properties
Handling Page-Level Exceptions

Module 3: Adding and Configuring Server Controls

Building Graphical User Interfaces with HTML Controls
Building Graphical User Interfaces with Web Server Controls
Programming Web Server Controls and Working with Postbacks

Module 4: Creating a Common Layout by Using Master Pages

Designing a Master Page
Adding and Configuring Content Pages
Designing Nested Master Pages

Module 5: Managing State for a Web Application

Configuring ViewState Properties for Web Server Controls
Storing and Retrieving Application and Session State
Implementing Out-of-Process Session State
Storing and Managing State Data in the Cache Object

Module 6: Accessing and Displaying Data

Creating and Retrieving Database Connections
Accessing Data by Using SqlDataSource Controls and Data Controls
Accessing Objects as Data with ObjectDataSource Controls
Accessing XML Data by Using XmlDataSource Controls

Module 7: Controlling Access to a Web Application

Configuring Authentication and Authorization for a Web Application
Implementing a Membership Registration Page
Implementing a Login Page and Adding Login Controls
Creating a Membership Management Administrative User Interface

Module 8: Deploying a Web Application

Deploying a Web Application by Using the Copy Web Site Utility
Precompiling and Deploying a Web Application by Using the Publish Web Site Utility
Building a Windows Installer Package for Deploying a Web Application

Module 9: Making Web Applications Available to Mobile Devices

Managing Redirection for Mobile Devices
Designing and Implementing a Mobile Web Form
Designing Device-Specific Features for a Mobile Web Application
Browsing a Mobile Web Application with Specific Device Emulators

Advanced Web Application Technologies with Microsoft Visual Studio 2005

Module 1: Building Dynamic Web Applications

Dynamically Adding and Configuring Controls
Dynamically Applying Master Pages
Adding Localization Features
Dynamically Configuring Web Applications

Module 2: Creating Controls for Web Applications

Creating User Controls
Creating Custom Web Server Controls
Creating Composite Web Server Controls
Creating Templated Controls

Module 3: Optimizing Web Application Performance

Accessing the Page Scripting Object Model
Implementing ASP.NET Caching Techniques
Implementing Tracing and Instrumentation Techniques in Web Applications
Implementing Asynchronous Processing in Web Applications

Module 4: Implementing Personalization and Themes in Web

Applications
Configuring Personalization
Implementing Personalization Functionality
Adding Themes to the Web Application
Implementing Personalized Themes

Module 5: Building Web Part Pages and Web Parts

Creating a Web Part Page
Creating a Web Part
Creating Connected Web Parts

Core Windows Forms with Microsoft Visual Studio 2005

Module 1: Creating a Simple Windows Forms Application

Adding and Configuring Windows Forms and Controls
Creating Event Handlers and Monitoring Events
Adding Controls and Handlers at Run Time
Adding a Form Keyboard Handler

Module 2: Configuring Standard Controls

Creating the EmployeeViewer Form
Creating the ReportGenerator Form
Creating the ReportGeneratorHelp Form

Module 3: Building Menus

Creating and Configuring a MenuStrip Control
Creating and Configuring a ContextMenuStrip Component
Hiding and Disabling a ToolStripMenuItem
Creating and Configuring a ToolStripComboBox

Module 4: Displaying and Editing Data by Using Data-Bound Controls

Adding a Data Source to a Project
Binding Data to a Control
Creating a Bound Form by Using the BindingSource and BindingNavigator Components
Displaying Data by Using the DataGridView Control
Binding to Data at Run Time

Module 5: Providing User Assistance and Enhancing Usability

Adding and Configuring User Assistance Controls
Implementing Accessibility Features
Implementing Globalization and Localization
Running a Procedure at Set Intervals
Displaying Data Source Errors

Module 6: Creating Consistent Applications by Using Dialog Boxes and Forms Inheritance

Adding and Configuring Dialog Box Components
Creating a Custom Dialog Box
Implementing Windows Forms Inheritance
Modifying an Existing Form to Inherit from a Base Form

Module 7: Printing Content and Creating Reports

Adding Print Capability to a Windows Forms Application
Implementing Reporting by Using the CrystalReportViewer Component

Module 8: Performing Asynchronous Tasks by Using the BackgroundWorker Component

Running and Canceling a Background Process by Using the BackgroundWorker Component

Module 9: Deploying Applications by Using ClickOnce

Publishing a ClickOnce Application
Installing and Testing a ClickOnce Application

Advanced Windows Forms with Microsoft Visual Studio 2005

Module 1: Building MDI Applications

Creating MDI Parent and Child Forms
Displaying and Comparing Information on MDI Child Forms
Implementing Menu Merging in MDI Applications

Module 2: Customizing Windows Forms and Controls

Creating a Control That Inherits from an Existing Control
Creating a Nonrectangular Windows Form
Creating a Custom User Control

Module 3: Creating Customized Print Components

Printing a Report by Using GDI+
Creating a Customized Print Preview Dialog Box

Module 4: Performing Drag-and-Drop Operations and

Implementing Clipboard Support
Implementing Drag-and-Drop Functionality in a Windows Forms Application
Adding Clipboard Support to an Application
Performing Drag-and-Drop Operations by Using TextBox and PictureBox Controls

Module 5: Performing Asynchronous Tasks by Using Multithreaded Techniques

Loading a Bitmap Asynchronously
Performing Calculations by Using Multithreading

Module 6: Enhancing the Presentation of Windows Forms

Applications
Programming the DataGridView Control
Viewing and Persisting Application Settings by Using the PropertyGrid Control
Implementing a User Interface in the Style of Outlook by Using RAD Features